数据库连接

数据库连接：

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

}

}