import java.sql.*;
public class InsertDemo01{
public static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver"; //定义SQLServer的数据库驱动程序
public static final String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=StockConfiguration"; //定义SQLServer数据库的连接地址
public static final String DBUSER="sa"; //SQLServer数据库的连接用户名
public static final String DBPASS="Fx5709"; //SQLServer数据库的连接密码
public static void main()throws Exception{
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String sql="select ConsumerId,TradingHours,Price ,BusinessDirection,Quantity from sh201101"; //表字段信息
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
Returns a hash code value for the object. This method is supported for the benefit of hash tables such as those provided by HashMap.
The general contract of hashCode is:
Whenever it is invoked on the same object more than once during an execution of a Java application, the hashCode method must consistently return the same integer, provided no information used in equals comparisons on the object is modified. This integer need not remain consistent from one execution of an application to another execution of the same application.
If two objects are equal according to the equals(Object) method, then calling the hashCode method on each of the two objects must produce the same integer result.
It is not required that if two objects are unequal according to the equals(java.lang.Object) method, then calling the hashCode method on each of the two objects must produce distinct integer results. However, the programmer should be aware that producing distinct integer results for unequal objects may improve the performance of hash tables.
As much as is reasonably practical, the hashCode method defined by class Object does return distinct integers for distinct objects. (This is typically implemented by converting the internal address of the object into an integer, but this implementation technique is not required by the JavaTM programming language.)
Returns:
a hash code value for this object.
See Also:
equals(java.lang.Object), System.identityHashCode(java.lang.Object)
import java.sql.*;
public class TestDemo01{
public static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver"; //定义SQLServer的数据库驱动程序
public static final String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=sh"; //定义SQLServer数据库的连接地址
public static final String DBUSER="sa"; //SQLServer数据库的连接用户名
public static final String DBPASS="Fx5709"; //SQLServer数据库的连接密码
while(rs.next()){
String id1=rs.getString("stockcode");//取出stockcode字段数据
int id2=id1.hashCode();//对取出的stockcode字段数据求哈希码
int id3=rs.getInt("num");//取出num字段数据
Returns a hash code value for the object. This method is supported for the benefit of hash tables such as those provided by HashMap.
The general contract of hashCode is:
Whenever it is invoked on the same object more than once during an execution of a Java application, the hashCode method must consistently return the same integer, provided no information used in equals comparisons on the object is modified. This integer need not remain consistent from one execution of an application to another execution of the same application.
If two objects are equal according to the equals(Object) method, then calling the hashCode method on each of the two objects must produce the same integer result.
It is not required that if two objects are unequal according to the equals(java.lang.Object) method, then calling the hashCode method on each of the two objects must produce distinct integer results. However, the programmer should be aware that producing distinct integer results for unequal objects may improve the performance of hash tables.
As much as is reasonably practical, the hashCode method defined by class Object does return distinct integers for distinct objects. (This is typically implemented by converting the internal address of the object into an integer, but this implementation technique is not required by the JavaTM programming language.)
Returns:
a hash code value for this object.
See Also:
equals(java.lang.Object), System.identityHashCode(java.lang.Object)
import java.sql.*;
public class TestDemo01{
public static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver"; //定义SQLServer的数据库驱动程序
public static final String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=sh"; //定义SQLServer数据库的连接地址
public static final String DBUSER="sa"; //SQLServer数据库的连接用户名
public static final String DBPASS="Fx5709"; //SQLServer数据库的连接密码
while(rs.next()){
String id1=rs.getString("stockcode");//取出stockcode字段数据
int id2=id1.hashCode();//对取出的stockcode字段数据求哈希码
int id3=rs.getInt("num");//取出num字段数据