package Jdbcday02;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class TestPk {
public static void main(String[] args) {
insert();
}
public static void insert() {
String sql="insert into sun_student(id,name,age,sex)" +
"values(myseq.nextval,?,?,?)";
Connection conn=null;
PreparedStatement psmt=null;
try {
conn = ConnectionUtils.openConnection();
psmt=conn.prepareStatement(sql);
psmt.setString(1, "gaoxuan");
psmt.setInt(2, 23);
psmt.setString(3, "F");
System.out.println(psmt.execute());//false时候返回的不是结果集合
} catch (SQLException e) {
e.printStackTrace();
}finally{
ConnectionUtils.closeStatement(psmt);
ConnectionUtils.closeConnection(conn);
}
}
}
jdbc 序列生成pk
最新推荐文章于 2022-07-09 13:10:35 发布