[問題] JSP 連 SQL 2008 的問題
這是我用JSP寫的 他是連SQL 2008
可是他好像因為我的資料型態 sex 是 bit birthday 是 data
所以它顯示錯誤 各位高手 請問要怎樣寫才可以修改
可以寫給我看嗎?
request.setCharacterEncoding("big5");
String id = request.getParameter("id");
String pw = request.getParameter("pw");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String birthday = request.getParameter("birthday");
String email = request.getParameter("email");
String phone = request.getParameter("phone");
String address = request.getParameter("address");
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch (Exception e) {
}
conn=DriverManager.getConnection(connectionUrl);
sql= "INSERT INTO Members(ID, Pw, Name, Sex, BDay, Email, Phone, Addr) VALUES
('" +id + "','" + pw + "','" + name + "','" + sex + "','" + birthday + "','"
+ email + "','" + phone + "','" + address + "')";
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
--
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.17.150.231