为什么我老是不能把表单的里的数据插入到数据库中去哟.又不会报错啊.总是插不里去.好奇怪.下下面是我的程序.请高手帮帮.
package db;
import java.sql.*;
public class ConnSQLServer {
//加载驱动程序
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user = "sa";
String password = "8112";
Connection connect = null;
ResultSet rs = null;
public ConnSQLServer() {
try{
Class.forName(DBDriver);
}catch(java.lang.ClassNotFoundException e) {
System.err.println(e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
connect=DriverManager.getConnection(url,user,password);
Statement stmt=connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql) {
int result = 0;
try{
connect = DriverManager.getConnection(url,user,password);
Statement stmt=connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
result = stmt.executeUpdate(sql);
}catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}
}
<%@ page contentType="text/html;charset=GBK"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id = "Conn" scope = "page" class = "db.ConnSQLServer"/>
<%!
String No = "";
String Sname = "";
String Age = "";
String Addr = "";
String sql = "";
%>
<%
request.setCharacterEncoding("GBK");
No = request.getParameter("no");
Sname = request.getParameter("name");
Age = request.getParameter("age");
Addr= request.getParameter("addr");
%>
<%=No%><br>
<%=Sname%><br>
<%=Age%><br>
<%=Addr%><br>
<%
sql = "Insert Into test1(no,name,age,addr) Values(";
sql += "'" + No + "',";
sql += "'" + Sname + "',";
sql += "'" + Age + "',";
sql += "'" +Addr + "',)";
Conn.executeUpdate(sql);
out.println("insert ok!");
//response.sendRedirect("pagev4.jsp");
%>
<html>
<body>
<center>
<FONT SIZE="8" COLOR="00ffff">请输入你要插入的数据</FONT>
<FORM METHOD=POST ACTION="insert.jsp">
学号:<INPUT TYPE="text" NAME="no"><BR>
姓名:<INPUT TYPE="text" NAME="name"><BR>
年龄:<INPUT TYPE="text" NAME="age"><BR>
地址:<INPUT TYPE="text" NAME="addr"><P>
<INPUT TYPE="submit" value=提交>
</FORM>
</center>
</body>
</html>
