//基于mysql的连接
Connection conn;
Statement smt;ResultSet rs;
String url="jdbc:mysql://localhost:3306/pro?useUnicode=true&characterEncoding=UTF-8";String user="root";
String password="root";
String sql="select * from users where username='"+uname+"' and password='"+pwd+"'";
DriverManager.registerDriver(new Driver()); //加载驱动
conn=DriverManager.getConnection(url, user, password); //连接
smt=conn.createStatement();
//查询
rs=smt.executeQuery(sql);
//更新,增加,删除
rs=smt.executeUpdate(sql);