到c:\java,再运行run.bat。
run.bat内容为:
set CLASSPATH=c:\java\mysql-connector-java-3.0.14-production-bin.jar;%CLASSPATH%
然后编译以下文件并运行测试。
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class TestmysqlZH extends JFrame{
public TestmysqlZH(){
Container contentPane=getContentPane();
contentPane.setLayout(new GridLayout(10,1,2,2));
JLabel lb;
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){
System.exit(0);
}
});
Connection Conn;
Statement Stmt;
ResultSet Rst;
String con_string="jdbc:mysql://localhost:3306";
con_string=con_string+"/soft?user=javauser;password=javadude";
try{
Class.forName("com.mysql.jdbc.Driver");
Conn = DriverManager.getConnection(con_string);
Stmt = Conn.createStatement();
String sql="select soft_name from soft where soft_id<10";
Rst=Stmt.executeQuery(sql);
while(Rst.next()){
String s=Rst.getString(1);
s=new String(s.getBytes("ISO8859_1"));
System.out.println(s);
lb=new JLabel(s);
contentPane.add(lb);
}
}catch(SQLException e){
System.out.println(e);
}catch(Exception e){ System.out.println(e);}
}
public static void main(String args[]){
TestmysqlZH t=new TestmysqlZH();
t.setSize(300,300);
t.show();
}
}</td> <td width="183" valign="top" class="ArticleTeitle">
</td> </tr> <tr> <td height="25" colspan="2" valign="top" class="ArticleTeitle">
↑返回目录
前一篇: ArrayList中的数据排序--java对象排序
后一篇: 把目录中的文件名全部改为小写