//我完成了一个实例,代码如下,在dos下最后的打印出来了.就是那个"v2",但读数据的打印怎么不显示呢?import java.sql.*;
//加载驱动
//建立连接
//提交请求
//返回结果
public class cnn
{public class jf extends JFrame
{
public jf()
{
JLabel lb1 = new JLabel();
container.add(lb1);
setSize(200,200);
setVisible(true);
}
};
public static void main(String[] args)
{String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ex";
String ls_1="select * from t1";
try //异常处理模块
{
//加载驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//建立连接
Connection con=DriverManager.getConnection(url,"sa","");
//,创建Statement实例,提交请求
Statement stmt=con.createStatement();
//返回结果
ResultSet result = stmt.executeQuery(ls_1); //返回结果//g.drawString("编号",40,40);
//g.drawString("名称",80,40);
//g.drawString("价值",160,40);
//int i=2;
while(result.next())
{
//取各个字段的值
System.out.println(result.getString("v1"));
System.out.println(result.getString("v2"));
//g.drawString(result.getString(1),40,60+i);
//g.drawString(result.getString(2),80,60+i);
//i+=20;
}
//关闭连接
result.close();
stmt.close();
con.close();
}
//捕获异常
catch(SQLException ex){}
catch(java.lang.Exception ex){} System.out.println("v2");
}
}
//加载驱动
//建立连接
//提交请求
//返回结果
public class cnn
{public class jf extends JFrame
{
public jf()
{
JLabel lb1 = new JLabel();
container.add(lb1);
setSize(200,200);
setVisible(true);
}
};
public static void main(String[] args)
{String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ex";
String ls_1="select * from t1";
try //异常处理模块
{
//加载驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//建立连接
Connection con=DriverManager.getConnection(url,"sa","");
//,创建Statement实例,提交请求
Statement stmt=con.createStatement();
//返回结果
ResultSet result = stmt.executeQuery(ls_1); //返回结果//g.drawString("编号",40,40);
//g.drawString("名称",80,40);
//g.drawString("价值",160,40);
//int i=2;
while(result.next())
{
//取各个字段的值
System.out.println(result.getString("v1"));
System.out.println(result.getString("v2"));
//g.drawString(result.getString(1),40,60+i);
//g.drawString(result.getString(2),80,60+i);
//i+=20;
}
//关闭连接
result.close();
stmt.close();
con.close();
}
//捕获异常
catch(SQLException ex){}
catch(java.lang.Exception ex){} System.out.println("v2");
}
}
读数据的怎么不显示呢.
什么原因??
急死我了import java.awt.*;
import java.applet.*;
import java .sql.*;
public class Applet1 extends Applet
{
public void init()
{
resize(400,300);
}public void paint(Graphics g) //此方法用于显示输出
{
this.setBackground(Color.lightGray ); //定义背景颜色
this.setForeground(Color.red); //定义前景颜色
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ex";
String ls_1="select * from t1";
try //异常处理模块
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //加载驱动程序
//建立连接
Connection con= DriverManager.getConnection(url,"sa","");
//执行SQL
Statement stmt=con.createStatement();
ResultSet result=stmt.executeQuery(ls_1); //返回结果
g.drawString("编号",40,40);
g.drawString("名称",80,40);
g.drawString("价值",160,40);
int i=2;
while(result.next())
{
//取各个字段的值
g.drawString(result.getString(1),40,60+i);
g.drawString(result.getString(2),80,60+i);
i+=20;
}
//关闭连接
result.close();
stmt.close();
con.close();
}
//捕获异常
catch(SQLException ex){}
catch(java.lang.Exception ex){} g.drawString("ok",35,35);
}}
现在是有异常
在这句 catch(java.lang.Exception ex){g.drawString("有异常,在行44",40,65);
///最新源码.大家救我.
import java.awt.*;
import java.applet.*;
import java .sql.*;
public class Applet1 extends Applet
{
public void init()
{
resize(400,300);
}public void paint(Graphics g) //此方法用于显示输出
{
this.setBackground(Color.lightGray ); //定义背景颜色
this.setForeground(Color.red); //定义前景颜色
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ex";
String ls_1="select * from t1";
try //异常处理模块
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //加载驱动程序
//建立连接
Connection con= DriverManager.getConnection(url,"sa","");
//执行SQL
Statement stmt=con.createStatement();
ResultSet result=stmt.executeQuery(ls_1); //返回结果
g.drawString("编号",40,40);
g.drawString("名称",80,40);
g.drawString("价值",160,40);
int i=2;
while(result.next())
{
//取各个字段的值
g.drawString(result.getString(1),40,60+i);
g.drawString(result.getString(2),80,60+i);
i+=20;
}
//关闭连接
result.close();
stmt.close();
con.close();
}
//捕获异常
catch(SQLException ex){g.drawString("有异常,a",40,60);}
catch(java.lang.Exception ex){g.drawString("有异常,在行44",40,65);
//输出异常信息 ex.printStackTrace()
}
g.drawString("程序执行到此",35,350);
}}