JDBC SQLserver

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();
					}
		}
		
	}

}