lianjie.java

来自「文件的上传和下载的实现,用JAva编写,非常简单」· Java 代码 · 共 43 行

package bao;
import java.sql.*;
public class Lianjie {
String qiaojie="sun.jdbc.odbc.JdbcOdbcDriver";
String connn="jdbc:odbc:shujuyuan";

public Lianjie()
   {
	try{Class.forName(qiaojie);}
	catch(ClassNotFoundException e){System.err.println(e.getMessage());}
	}
public ResultSet connect(String sql)
{
	ResultSet rs=null;
	try{Connection conn=DriverManager.getConnection(connn,"","");
     Statement st=conn.createStatement();
	 rs=st.executeQuery(sql);}
	 catch(SQLException e){
		 System.err.println(e.getMessage());}
return rs;
}
/*
public static void main(String[] args) throws SQLException {
	 //TODO 自动生成方法存根
	Lianjie wo=new Lianjie();
    
	ResultSet haha=wo.connect("select * from biao");
	 int num=0; 
	
	   System.out.println("ddddd"); 
	  while(haha.next())
	  {
		  System.out.println(haha.getString("name"));
	  num++;
	  }
	  haha.close();
	  System.out.println(num);
}*/

}