jsp联结sqlserver问题。这句有什么问题
数据库已建好,从一个HTM页面传递数据到以下文件,提示("成功插入数据")
可是从数据库中查不到所插入的数据,这句话有什么问题?
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
String username1;
String password1;
String email;
String name1;
String sex;
String address;
String zipcode;
String phone;
String logip;
String register_date;
username1=request.getParameter("username1");
password1=request.getParameter("password1");
email=request.getParameter("email");
name1=request.getParameter("name1");
sex=request.getParameter("sex");
address=request.getParameter("address");
zipcode=request.getParameter("zipcode");
phone=request.getParameter("phone");
// logip=request.getRemoteAddr();
//java.util.Date logtime1=new java.util.Date();
//register_date=(logtime1.getYear()+1900)+"-"+(logtime1.getMonth()+1)+"-"+(logtime1.getDate());
%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=work1";
//test为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String querystring="insert into register(username1,password1,logtime,email,name1)";
//querystring=querystring+"sex,address,zipcode,phone,logip) values('";
// querystring=querystring+username1+"','"+password1+"','"+register_date+"','"+email+"','";
// querystring=querystring+name1+"','"+sex+"','"+address+"','"+zipcode+"','"+phone+"','"+logip+"')";
// stmt.executeUpdate(querystring);
// stmt.close();
// con.close();
out.println("成功插入数据");
//catch(Exception e)
%>