jdbc中preparedstatement用法

import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


import javax.swing.JApplet;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;


import com.mysql.jdbc.PreparedStatement;


public class myFindGrade extends JApplet {


static JTextField jtf01 = new JTextField(10);
static java.sql.PreparedStatement statement;
static ResultSet resultset;
static String arg01;


public myFindGrade() {


JLabel jbabel01 = new JLabel("courseId");
JButton jbtn01 = new JButton("seachr");
this.add(jbabel01);
this.add(jtf01, BorderLayout.SOUTH);
this.add(jbtn01, BorderLayout.CENTER);
this.setLayout(new FlowLayout());
jbtn01.addActionListener(new myListener());
try {
initGrid();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}


}


private static class myListener implements ActionListener {


@Override
public void actionPerformed(ActionEvent arg0) {
arg01 = jtf01.getText().toString();


try {
// resultset =
// statement.executeQuery("select courseid from course where courseid = "+arg01);
statement.setString(1, arg01);
resultset=statement.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
while (resultset.next()) {
System.out.println(resultset.getString(1));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


}


}


public void initGrid() throws ClassNotFoundException, SQLException {


String mysql_driver = "com.mysql.jdbc.Driver";
String mysql_address = "jdbc:mysql://localhost/test";
String mysql_username = "root";
String mysql_password = "root";
// 加載驅動
Class.forName(mysql_driver);
Connection connection = DriverManager.getConnection(mysql_address,
mysql_username, mysql_password);
System.out.println("connection established!");


//这里是具体的查询语句
String queryString = "select courseid from course where courseid = ?";
//这里执行查询
statement = connection.prepareStatement(queryString);
System.out.println("statement ready!");


}


public static void main(String[] args) {
// TODO Auto-generated method stub
myFindGrade mfg = new myFindGrade();
}

}

www.csafterclass.com专业it图书下载站