小弟在java applets中想写和数据库进行连接的程序~
不知道是在init中写还是在那里写
import java.awt.*;
import java.applet.*;
import java.sql.*;
import java.net.URL;
import java.text.*;
public class Uferp extends Applet {
// List lisBox = new List();Button but1 = new Button();
public void Conn(){
// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
/* Connection Con;
Statement Cmd;
ResultSet Rs;
try{
Con = DriverManager.getConnection("jdbc:odbc:ierp","sa","sa");
Cmd = Con.createStatement();
Rs = Cmd.executeQuery("select cuser_id,cuser_name from ufsystem.dbo.ua_user");
while(Rs.next()){
this.lisBox.add(Rs.getString("cuser_name"));
}
}
catch(SQLException error)
{
}
*/
}
public void init() {
/* String url = "jdbc:odbc:ierp";
//取得连接的url名,注意sqlserver是dsn名
Connection con;
//实例化一个Connection对象
Statement stmt;
// String query = "select * from col_link";
//选择所有的Col_link表中的数据输出
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//加载jdbc-odbc桥驱动
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
//加载jdbc-odbc桥错误
System.err.println(e.getMessage());
//其他错误
}
con = DriverManager.getConnection(url,"sa","sa");
//数据库连接
stmt = con.createStatement();
//Create 一个声明
// stmt.executeQuery("select cuser_id,cuser_name from ufsystem.dbo.ua_user");
ResultSet rs = stmt.executeQuery("select cuser_id,cuser_name from ufsystem.dbo.ua_user");
while(rs.next()){
this.lisBox.add(rs.getString("cuser_name"));
}
*/
this.setBackground(Color.cyan);
// add(this.lisBox);
add(but1.setName("按钮1"));
add(new Button("按钮2"));
add(new Button("按钮3"));
} public void paint(Graphics g) {
// g.drawString("Welcome to Java!!", 50, 60 );
}
public boolean HandlerEvent(Event evt)
{
switch(evt.id)
{
case Event.ACTION_EVENT:
{
if (but1..equals(evt.arg))
{
this.showStatus("您按下1钮!"); return true;
}
}
default: return false;
}
}
}
不知道是在init中写还是在那里写
import java.awt.*;
import java.applet.*;
import java.sql.*;
import java.net.URL;
import java.text.*;
public class Uferp extends Applet {
// List lisBox = new List();Button but1 = new Button();
public void Conn(){
// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
/* Connection Con;
Statement Cmd;
ResultSet Rs;
try{
Con = DriverManager.getConnection("jdbc:odbc:ierp","sa","sa");
Cmd = Con.createStatement();
Rs = Cmd.executeQuery("select cuser_id,cuser_name from ufsystem.dbo.ua_user");
while(Rs.next()){
this.lisBox.add(Rs.getString("cuser_name"));
}
}
catch(SQLException error)
{
}
*/
}
public void init() {
/* String url = "jdbc:odbc:ierp";
//取得连接的url名,注意sqlserver是dsn名
Connection con;
//实例化一个Connection对象
Statement stmt;
// String query = "select * from col_link";
//选择所有的Col_link表中的数据输出
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//加载jdbc-odbc桥驱动
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
//加载jdbc-odbc桥错误
System.err.println(e.getMessage());
//其他错误
}
con = DriverManager.getConnection(url,"sa","sa");
//数据库连接
stmt = con.createStatement();
//Create 一个声明
// stmt.executeQuery("select cuser_id,cuser_name from ufsystem.dbo.ua_user");
ResultSet rs = stmt.executeQuery("select cuser_id,cuser_name from ufsystem.dbo.ua_user");
while(rs.next()){
this.lisBox.add(rs.getString("cuser_name"));
}
*/
this.setBackground(Color.cyan);
// add(this.lisBox);
add(but1.setName("按钮1"));
add(new Button("按钮2"));
add(new Button("按钮3"));
} public void paint(Graphics g) {
// g.drawString("Welcome to Java!!", 50, 60 );
}
public boolean HandlerEvent(Event evt)
{
switch(evt.id)
{
case Event.ACTION_EVENT:
{
if (but1..equals(evt.arg))
{
this.showStatus("您按下1钮!"); return true;
}
}
default: return false;
}
}
}
网上这方面的原代码很多的,搜一下jdbc等相关的吧!
ps:Conn方法首字母建议小写
copy下面的试试看
//-----------------------
import java.awt.*;
import java.applet.*;
import java.sql.*;
import java.net.URL;
import java.text.*;public class Uferp extends Applet {
List lisBox = new List(); Button but1 = new Button("按钮1"); public void Conn() {
// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver"); Connection Con;
Statement Cmd;
ResultSet Rs;
try {
Con = DriverManager.getConnection("jdbc:odbc:ierp", "sa", "sa");
Cmd = Con.createStatement();
Rs = Cmd
.executeQuery("select cuser_id,cuser_name from ufsystem.dbo.ua_user");
while (Rs.next()) {
this.lisBox.add(Rs.getString("cuser_name"));
}
} catch (SQLException error) { } } public void init() { /*
* String url = "jdbc:odbc:ierp"; //取得连接的url名,注意sqlserver是dsn名
* Connection con; //实例化一个Connection对象 Statement stmt; // String query =
* "select * from col_link"; //选择所有的Col_link表中的数据输出
*
* try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载jdbc-odbc桥驱动
* } catch(java.lang.ClassNotFoundException e) {
* System.err.print("ClassNotFoundException: "); //加载jdbc-odbc桥错误
* System.err.println(e.getMessage()); //其他错误 }
*
*
* con = DriverManager.getConnection(url,"sa","sa"); //数据库连接
*
*
* stmt = con.createStatement(); //Create 一个声明 //
* stmt.executeQuery("select cuser_id,cuser_name from
* ufsystem.dbo.ua_user"); ResultSet rs = stmt.executeQuery("select
* cuser_id,cuser_name from ufsystem.dbo.ua_user"); while(rs.next()){
* this.lisBox.add(rs.getString("cuser_name")); }
*/
this.setBackground(Color.cyan); // add(this.lisBox); add(but1);
add(new Button("按钮2"));
add(new Button("按钮3"));
} public void paint(Graphics g) {
// g.drawString("Welcome to Java!!", 50, 60 );
} public boolean HandlerEvent(Event evt) {
switch (evt.id) {
case Event.ACTION_EVENT: {
if (but1.equals(evt.arg)) {
this.showStatus("您按下1钮!"); return true;
}
}
default:
return false;
} }
}