//这是DBManage
import java.sql.*;
public class JdbcUpdate {
private static final String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String url="jdbc:sqlserver://127.0.0.1:1433;DataBaseName=SanGuoSha";
private static final String uid="sa";
private static final String pwd="123456";
public static Connection conn=null;
public static PreparedStatement pst=null;
public static ResultSet rst=null;
/**
* 关闭连接
* @param conn Connection对象
* @param pst PreparedStatement对象
* @param rst ResultSet对象
*/
public static void Close(Connection conn,PreparedStatement pst,ResultSet rst)
{
try {
if(conn!=null){
conn.close();
conn=null;
}
if(pst!=null){
pst.close();
pst=null;
}
if(rst!=null){
rst.close();
rst=null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private static Connection getConn(){
try {
Class.forName(driver);
conn=DriverManager.getConnection(url, uid, pwd);
//PreparedStatement
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
//
public static ResultSet Select(String sql){
try {
pst=getConn().prepareStatement(sql);
rst=pst.executeQuery();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rst;
}
//这是调用
String sql="select * from Wujiang";
ResultSet rst=JdbcUpdate.Select(sql);
try {
while(rst.next()){
int id=rst.getInt(1);
String name=rst.getString(2);
int hp=rst.getInt(3);
String skill=rst.getString(4);
int emo=rst.getInt(5);
System.out.println("编号:"+id+"\t姓名:"+name+"\t血量:"+hp+"\t技能:"+skill+"\t情义值:"+emo);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
JdbcUpdate.Close(JdbcUpdate.conn, JdbcUpdate.pst, JdbcUpdate.rst);
System.out.println(JdbcUpdate.conn);
System.out.println(JdbcUpdate.pst);
System.out.println(JdbcUpdate.rst);
}
//这是结果
![图片说明](https://img-ask.csdn.net/upload/201703/22/1490158128_936267.png)
这个中间的1是什么意思