Test

public class Test {

	public static void main(String[] args)
	{
		String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=你的数据库名字";
		Connection connection=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			connection=(Connection) DriverManager.getConnection(url,"数据库账号","密码");
			String sql="select count(*) from denglu where zhanghao=? and mima=?"; //示例 sql语句 用?代替参数 后面补偿
			ps=(PreparedStatement) connection.prepareStatement(sql);
			ps.setString(1,值);//第一参数的值
			ps.setString(2, 值);//第二参数的值
			rs=(ResultSet) ps.executeQuery();
			
			while(rs.next())
			{
				String a=rs.getString("数据库字段民");
				String b=rs.getInt("数据库字段名");
				String c=rs.getDate("数据库字段");
				
			}
			
			  }
			catch(ClassNotFoundException e)
			{e.printStackTrace();
		
			}
			catch(SQLException e)
			{   
				e.printStackTrace();
			
			}
			catch(Exception e)
			{
				e.printStackTrace();
			
			}
			finally
			{
				try {
					if(connection!=null) connection.close();
					if(ps!=null) ps.close();
					if(rs!=null) rs.close();
					
				    }
				catch(SQLException e)
				{
					e.printStackTrace();
					
				}
				catch(Exception e)
				{
					e.printStackTrace();
				}
				
				
			}
	
		
		
		
	}
	
	
}