package s1;
import java.sql.*;
import java.awt.BorderLayout;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JButton;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ss1 extends JFrame {
private JPanel contentPane;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
ss1 frame = new ss1();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the frame.
*/
public ss1() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 450, 300);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(50, 86, 200, 166);
contentPane.add(scrollPane);
JTextArea textArea = new JTextArea();
scrollPane.setViewportView(textArea);
JButton btnNewButton = new JButton("New button");
btnNewButton.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch (ClassNotFoundException ce)
{System.out.println("sql exception"+ce.getMessage());}
try{
Connection conn = DriverManager.getConnection("jdbc:odbc:a1", "a1", "a1");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select sname,sex from employee"); //xuanze
String s="";
while (rs.next()) {
System.out.println(
s=s+rs.getString(1)
);
}
rs.close();
stmt.close();
conn.close();
}
catch(SQLException e)
{System.out.println("sqlexception:"+e.getMessage());}
}
});
btnNewButton.setBounds(50, 28, 93, 23);
contentPane.add(btnNewButton);
}
}
错误如下
sql exceptioncom.mysql.jdbc.Driver
sqlexception:No suitable driver found for jdbc:odbc:a1
