sql 爪哇
来源:百度知道 编辑:UC知道 时间:2024/06/22 20:46:42
package pinlebao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
public class Sjklj {
Connection cn = null;
ResultSet rs = null;
Statement st = null;
Connection getConnect() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (Exception ex1) {
}
try {
cn = DriverManager.getConnection("Jdbc:Odbc:test");
} catch (SQLException ex2) {
}
try {
st = cn.createStatement();
} catch (SQLException ex3) {
}
try {
rs = st.executeQuery(sql);//做 查
//st.executeUpdate(); //做 增删改
} catch (SQLException ex3) {System.out.println("发生异常!
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
public class Sjklj {
Connection cn = null;
ResultSet rs = null;
Statement st = null;
Connection getConnect() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (Exception ex1) {
}
try {
cn = DriverManager.getConnection("Jdbc:Odbc:test");
} catch (SQLException ex2) {
}
try {
st = cn.createStatement();
} catch (SQLException ex3) {
}
try {
rs = st.executeQuery(sql);//做 查
//st.executeUpdate(); //做 增删改
} catch (SQLException ex3) {System.out.println("发生异常!
executeQuery
只是执行select .......语句用的返回的是一个ResultSet对象..里边包含的是之后了select语句以后的结果
executeUpdate是针对update,delete 等数据操作语句的,返回的是一个int类型的整数,是执行了那个语句以后数据库所修改的行数..
推荐你去了解一下hibernate或者其他的持久层框架吧.
然后去看一些mvc方面的资料