📄 lianjie.java
字号:
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);
}*/
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -