1 package org.west.demo2;
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.PreparedStatement;
6 import java.sql.SQLException;
7
8 //
9 public class Test {
10 public static void main(String[] args) throws ClassNotFoundException, SQLException {
11 Class.forName("com.mysql.jdbc.Driver");
12 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbcstudy", "root", "123456");
13
14 String sql="insert into t_user (Sname,pwd) values (?,?)";// ?占位符
15
16 PreparedStatement statement = connection.prepareStatement(sql);
17
18
19 // statement.setString( 1,"zhaoliu"); //参数1 索引从1开始而不是从0开始计算
20 // statement.setString(2,"1234567"); //参数2
21 //我们不知道向里面添加什么类型可以使用setobject
22 //传参
23 statement.setObject(1,"dandan");
24 statement.setObject(2,"987654");
25
26 int i = statement.executeUpdate();
27 System.out.println(i);
28
29 }
30 }