来吧看看代码,就是简单操作:
public class BookService {
public void salebook(int id,int amo) {
String url="jdbc:mysql://localhost:3306/java1022";
String name="root";
String pwd="";
//创建一个connection
Connection conn=null;
PreparedStatement ps=null;
PreparedStatement ps1=null;
PreparedStatement ps2=null;
ResultSet rs=null;
try {
conn=DriverManager.getConnection(url,name,pwd);
//1.查询数库中的数量是否足够
ps=conn.prepareStatement("select booknum from t_number where bookid=?");
public class BookService {
public void salebook(int id,int amo) {
String url="jdbc:mysql://localhost:3306/java1022";
String name="root";
String pwd="";
//创建一个connection
Connection conn=null;
PreparedStatement ps=null;
PreparedStatement ps1=null;
PreparedStatement ps2=null;
ResultSet rs=null;
try {
conn=DriverManager.getConnection(url,name,pwd);
//1.查询数库中的数量是否足够
ps=conn.prepareStatement("select booknum from t_number where bookid=?");