mysql.txt

jsp与数据库开发的全部代码

Class.forName("org.gjt.mm.mysql.Driver").newInstance();
//datebase为你的数据库名
String url ="jdbc:mysql://localhost/datebase?user=""&password=""&use 
Unicode=true&characterEncoding=8859_1";
//创建数据库连接
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, 
ResultSet.CONCUR_UPDATABLE);
//取出test表内的所有字段
String sql="select * from test";
//执行sql语句
ResultSet rs=stmt.executeQuery(sql);