java连sql sever_JAVA连接SQL SERVER 实例

package mysql.login.sansom;

import java.sql.*; public class login { public static void main(String[] args) { Connection con=null; Statement stmt=null; ResultSet rs=null; String num="sansom"; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test","sa","123456"); // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// con = DriverManager.getConnection("jdbc:odbc:JDBCSQLDemo_JSPTest"); stmt = con.createStatement(); String sql="select username,password from admin_id where username ='"+num+"'" ; rs = stmt.executeQuery(sql); while(rs.next()){ String strUserName = rs.getString(1); //String strPassWord = rs.getString(2); //String strEmail = rs.getString(3);//("email"); // System.out.println(strUserName+"\t"+strPassWord+"\t");

if (strUserName.equals(num)){

System.out.print("YES!");

}else{

System.out.print("NO!");

}

} if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(con!=null) con.close(); } catch (Exception e) { e.printStackTrace(); }finally{ System.out.println("Game Over~");

} } }