来源: <body><center>
<%@ page language=\"java\" import=\"java.sql.*,MyUtil\" contentType=\"text/html;charset=gb2312\" %>
<%String driver=\"org.gjt.mm.mysql.Driver\";
String url=\"jdbc:mysql://compaq:3306/jxgl\";
String user=\"songbo\";
String password=\"songbo\";
try {
Class.forName(driver);
}
catch(Exception e) {
out.println(\"无法加载驱动程序!!\"+driver);
e.printStackTrace();
}
String cno[ ]={\"01001\"};
String cname[ ]={\"计算机应用基础\"};
try {
Connection con=DriverManager.getConnection(url,user,password);
PreparedStatement pmst=con.prepareStatement(\"UPDATE course SET course_name=? WHERE course_no=?\");
for(int i=0;i<cno.length;i++) {
pmst.setString(1,MyUtil.UnicodeToGb2312(cname[i]));
pmst.setString(2,cno[i]);
pmst.executeUpdate();
}
pmst.close();
%>
修改后的课程情况一览表
<table border=\"1\">
<tr><th>课程号</th><th>课程名称</th><th>学分</th></tr>
<%
Statement smt = con.createStatement();
ResultSet rst = smt.executeQuery(\"select * from course\");
while(rst.next()) { //把记录指针移动到下一个记录
out.println(\"<tr><td>\"+rst.getString(\"course_no\")+\"</td>\");
out.println(\"<td>\"+rst.getString(\"course_name\")+\"</td>\");
out.println(\"<td>\"+rst.getString(\"course_score\")+\"</td></tr>\");
}
smt.close();
con.close();
}
catch(SQLException ee) {
System.out.println(\"数据库连接失败!\");
}
%>
</center></body></html>
Tags: 用jsp修改mysql数据表中的数据,
分类:JSP
阅读:
评论: