求大神指点迷津
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" contentType="text/html;charset=UTF-8"
import="java.sql.*,java.io.*"%>
<html>
<head>
</head>
<body>
<center>往数据库中添加数据<hr>
<%
try{
//装载驱动程序
Class.forName("com.mysql.jdbc.Driver").newInstance();
//创建连接
Connection con=java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ch12"
,"root","root");
//创建执行语句
//使用PreparedStatement
PreparedStatement pstmt=con.prepareStatement("insert into customer values(?,?,?,?)");
//添加第一条记录
pstmt.setInt(1,1);
pstmt.setString(2,"beyound@sohu.com");
pstmt.setString(3,"111");
pstmt.setString(4,"1992-09-22");
pstmt.execute();
//添加第二条记录
pstmt.setInt(1,2);
pstmt.setString(2,"dshkfha@baidu.com");
pstmt.setString(3,"222");
pstmt.setString(4,"1992-09-20");
pstmt.execute();
//添加第三条记录
pstmt.setInt(1,3);
pstmt.setString(2,"kjyirey@Google.com");
pstmt.setString(3,"333");
pstmt.setString(4,"1992-09-21");
pstmt.execute();
//使用Stetement
Statement stmt=con.createStatement();
//一次添加一行数据
stmt.execute("insert into customer(id,email,password,birthday)values(4,'liuwei@yahoo.com','11111','1992-09-25')");
//关闭连接,释放资源
stmt.close();
con.close();
out.println("添加数据成功");
}catch(Exception e){
e.printStackTrace();
}
%>
</center>
</body>
</html>
新手疑惑,求大神帮忙看一下,往数据库中插入不了数据,上面的代码没有执行,谢谢!!