数据库连接:
public class Test{
Connection connection = null ;
public static void main(String[] args){
try{
//加载mysql驱动
Class.forName (Driver.NAME);
//获取数据库连接
connection = driverManager.getConnection(url,userName,userPwd);
//SQL语句
String sql = "select * from sys_user"
//处理命令
PreparedStatement pre = new PreparedStatement(sql);
//结果集
ResultSet res = pre.excuteQuey();
//输出结果集
while(res.hasnext){
system.outPrintIn(res.getString(name));
}
res.close();
pre.close();
}
catch(Exception exp){
exp.printStackTrace();
}
}