Question

请问你可以帮我一个忙吗？我需要用JAVA做一个数据库连接还要增删改查的源代码，我快要交作业了，帮帮忙。

Answer 1

数据库连接-预编译PreparedStatement
查询，删除，结果并显示
import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
publicclass FindGradeUsingPreparedStatement extends JApplet {
private JTextField jtfSNO = new JTextField(9);
private JTextField jtfCNO = new JTextField(5);
private JButton jbtShowGrade = new JButton("ShowGrade");
//PreparedStatement for executing queries
private PreparedStatement preparedStatement;
/**Initialize the applet */
publicvoid init() {
//Initialize database connection and create a Statement object
initializeDB();
jbtShowGrade.addActionListener(
new java.awt.event.ActionListener() {
publicvoid actionPerformed(ActionEvent e) {
jbtShowGrade_actionPerformed(e);
}
});
JPanel jPanel1 = new JPanel();
jPanel1.add(new JLabel("SNO"));
jPanel1.add(jtfSNO);
jPanel1.add(new JLabel("CNO"));
jPanel1.add(jtfCNO);
jPanel1.add(jbtShowGrade);
add(jPanel1, BorderLayout.CENTER);
}
privatevoid initializeDB() {
try {
// Loadthe JDBC driver
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// Class.forName("oracle.jdbc.driver.SQLServerDriver");
System.out.println("Driver loaded");
//Establish a connection
Connection connection = DriverManager.getConnection
("jdbc:sqlserver://localhost:1433;DatabaseName=student","sa", "14YUzhou");
// ("jdbc:sqlserver://localhost:1433;DatabaseName=student","sa","14YUzhou");
System.out.println("Database connected");
String queryString = "select SName, Dept, Cname, Grade From S,C,SC " +
"where S.SNO = ? and SC.CNO = ? " + " AND SC.Cno=C.Cno" + " ANDSC.SNO=S.SNO" ;
// Createa statement
preparedStatement = connection.prepareStatement(queryString);
}
catch (Exception ex) {
ex.printStackTrace();
}
}
privatevoid jbtShowGrade_actionPerformed(ActionEvent e) {
String SNO = jtfSNO.getText();
String CNO = jtfCNO.getText();
try {
preparedStatement.setString(1, SNO);
preparedStatement.setString(2, CNO);
ResultSet rset = preparedStatement.executeQuery();
if (rset.next()) {
String SName = rset.getString(1);
String Dept = rset.getString(2);
String Cname = rset.getString(3);
String Grade = rset.getString(4);
// Display result in a dialog box
JOptionPane.showMessageDialog(null, SName + " " + Dept + " " + Cname +" "+ Grade );
}
else {
// Display result in a dialog box
JOptionPane.showMessageDialog(null, "Not found");
}
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
/** Mainmethod */
publicstaticvoid main(String[] args) {
FindGradeUsingPreparedStatement applet = new
FindGradeUsingPreparedStatement();
JFrame frame = new JFrame();
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setTitle("Find Grades");
frame.getContentPane().add(applet,BorderLayout.CENTER);
applet.init();
applet.start();
frame.setSize(380, 80);
frame.setLocationRelativeTo(null); // Center the frame
frame.setVisible(true);
}
}

Answer 2

我的文库里有现成的，你直接拿去用就OK

Answer 3

只要是连到数据库，并且能增删改查就可以了？

Answer 4

oracle数据库可以吗

追问

抱歉哦，我们要用odbc进行连接，是用SQL或assess创建的数据，谢谢哦。。