import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestJdbc1 {
public static void main(String[]args){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=qtliu";
String name="sa";
String passwd="";
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,name,passwd);
stmt=conn.createStatement();
String sql="insert into qt(name,passwd) values('qtliu','admin')";
String sql1="insert into qt(name,passwd) values('刘奇庭','admin')";
String sqlfindall="select *from qt";
stmt.executeUpdate(sql);
stmt.executeUpdate(sql1);
rs=stmt.executeQuery(sqlfindall);
while (rs.next()){
System.out.println("用户名:"+rs.getString(2)+";"+"密码"+rs.getString(3)+"\n");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
}
}catch(Exception er){
er.printStackTrace();
}
try{
if(stmt!=null){
rs.close();
}
}catch(Exception es){
es.printStackTrace();
}
try{
if(conn!=null){
rs.close();
}
}catch(Exception ec){
ec.printStackTrace();
}
}
}
}
JDBC SQLserver
最新推荐文章于 2024-05-28 15:17:40 发布