现在一点表单提交的时候 页面就跳不过去到add.jsp了 而且转到了Conndb注释的那一行 还出来什么Dubeg的 ,不知道是那里的问题呢?
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%request.setCharacterEncoding("utf-8");%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>填写信息 </title>
</head>
<body>
<form id="form1" name="form1" method="post" action="add.jsp">
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>姓名:</td>
<td><input type="text" name="uname" /></td>
</tr>
<tr>
<td>性别:</td>
<td><input type="radio" name="usex" value="男" />
男
<input type="radio" name="usex" value="女" />
女</td>
</tr>
<tr>
<td>年龄:</td>
<td><input type="text" name="uage" /></td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="提交" /></td>
<td><input type="reset" name="Submit2" value="重置" /></td>
</tr>
</table>
</form>
</body>
</html>连接数据库的代码:package db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Conndb {
public static Connection start(){
Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:student","","");
} catch (ClassNotFoundException e) {
System.out.println("类文件未找到!");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("连接出现异常");
e.printStackTrace();
}
return conn;
}
public static int Update(String uname,String ussex,String uage){
Connection conn = null;//这一行有问题吗??
PreparedStatement pt=null;
int i =0;
try {
conn = start();
String sql = "insert into student(sname,ssex,sage) values('"+uname+"','"+ussex+"','"+uage+"')";
pt = conn.prepareStatement(sql);
pt.setString(1, uname);
pt.setString(2,ussex);
pt.setString(3,uage);
i= pt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
close(pt,conn);
}
return i ;
}
public static void close(PreparedStatement pt,Connection conn){
try {
if(pt!=null){
pt.close();
pt=null;
}
if(conn!=null){
conn.close();
conn=null;
}
} catch (SQLException e) {
System.out.println("关闭时发生异常1");
e.printStackTrace();
}
}
public static void close(Connection conn){
try {
if(conn!=null){
conn.close();
conn=null;
}
} catch (SQLException e) {
System.out.println("关闭时出现异常2");
e.printStackTrace();
}
}}add.jsp
<%@ page language="java" import="java.util.*,db.Conndb" pageEncoding="utf-8"%>
<%request.setCharacterEncoding("utf-8");%>
<%String uname = request.getParameter("uname");
String ussex = request.getParameter("usex");
String uage = request.getParameter("uage");
int i = Conndb.Update(uname,ussex,uage);
if (i >0){%>
<font color="blue"> 插入成功!</font><br>
<% }
else{%>
<font color="red">插入失败!</font><br>
<% }%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'add.jsp' starting page</title>
</head>
<body>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货