JDBC 链接Mysql 做了一次添加 

 1 import java.sql.*;
 2 import java.text.SimpleDateFormat;
 3 public class add_jdbc {
 4     public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
 5     public static final String DBURL="jdbc:mysql://127.0.0.1:3306/shuai";
 6     public static final String DBUSER="root";
 7     public static final String DBPASS="root";
 8     public static void main(String[] args) throws Exception{
 9         Connection conn=null;
10         PreparedStatement pstmt=null;
11         String name="tom";
12         String password="12345678";
13         int age=30;
14         String birthday="1987-08-07";
15         java.util.Date temp=null;
16         temp=new SimpleDateFormat("yyyy-MM-dd").parse(birthday);
17         java.sql.Date bir=new java.sql.Date(temp.getTime());
18         String sql="insert into h_user(username,pwd,age,date)"+" values(?,?,?,?)";
19         Class.forName(DBDRIVER);//加载驱动程序
20         conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);//连接数据库时 要写上连接的地址用户名和密码
21         pstmt=conn.prepareStatement(sql);//
22         pstmt.setString(1, name);
23         pstmt.setString(2, password);
24         pstmt.setInt(3, age);
25         pstmt.setDate(4, bir);
26         pstmt.executeUpdate();
27         pstmt.close();
28         conn.close();
29     }
30 }
 1 import java.sql.*;
 2 import java.text.SimpleDateFormat;
 3 public class add_jdbc {
 4     public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
 5     public static final String DBURL="jdbc:mysql://127.0.0.1:3306/shuai";
 6     public static final String DBUSER="root";
 7     public static final String DBPASS="root";
 8     public static void main(String[] args) throws Exception{
 9         Connection conn=null;
10         PreparedStatement pstmt=null;
11         String name="tom";
12         String password="12345678";
13         int age=30;
14         String birthday="1987-08-07";
15         java.util.Date temp=null;
16         temp=new SimpleDateFormat("yyyy-MM-dd").parse(birthday);
17         java.sql.Date bir=new java.sql.Date(temp.getTime());
18         String sql="insert into h_user(username,pwd,age,date)"+" values(?,?,?,?)";
19         Class.forName(DBDRIVER);//加载驱动程序
20         conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);//连接数据库时 要写上连接的地址用户名和密码
21         pstmt=conn.prepareStatement(sql);//
22         pstmt.setString(1, name);
23         pstmt.setString(2, password);
24         pstmt.setInt(3, age);
25         pstmt.setDate(4, bir);
26         pstmt.executeUpdate();
27         pstmt.close();
28         conn.close();
29     }
30 }

 

 

posted @ 2017-07-11 21:36  ADUS_二爷  阅读(88)  评论(0)    收藏  举报