//import java.sql.*
Connection conn=null
Statement stmt=null
ResultSet rs=null
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
String url="jdbc:odbc:%%1"
con=DriverManager.getConnection(url,%%2,%%3)
stmt=conn.createStatement()
stmt.executeUpdate(%%4)
rs=stmt.executeQuery(%%5)
}catch(Exception e){
e.printStackTrace()
}
finally{
try {
if(rs!=null)
rs.close()
if(stmt!=null)
stmt.close()
if(conn!=null)
conn.close()
} catch (SQLException e) {
e.printStackTrace()
}
}
3.显示表格
/*
import java.awt.*
import javax.swing.*
import java.sql.*
import javax.swing.table.*
*/
String[] colHeads=%%4
Connection conn=null
Statement stmt=null
ResultSet rs=null
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
String url="jdbc:odbc:%%1"
conn=DriverManager.getConnection(url,%%2,%%3)
stmt=conn.createStatement()
rs=stmt.executeQuery("SELECT count(*) as au_count from "+%%5)
rs.next()
int iCount=rs.getInt("au_count")
Object[][] data=new Object[iCount][]
int i=0
rs=stmt.executeQuery("SELECT * from "+%%5)
while(rs.next()){
data[i]=new Object[iCount]
data[i][0]=rs.getString("au_fname")
data[i][1]=rs.getString("Phone")
data[i][2]=rs.getString("City")
i++
}
JTable table=new JTable(data,colHeads)
JScrollPane jsp=new JScrollPane(table)
getContentPane().add(jsp)
}catch(Exception e){
e.printStackTrace()
}
finally{
try {
if(rs!=null)
rs.close()
if(stmt!=null)
stmt.close()
if(conn!=null)
conn.close()
} catch (SQLException e) {
e.printStackTrace()
}
}
6.关闭时关闭连接
//import java.sql.*
addWindowListener(new WindowAdapter{
public void windowClosing(WindowEvent wevent){
if(stmt!=null){
try {
if(rs!=null)
rs.close()
if(stmt!=null)
stmt.close()
if(conn!=null)
conn.close()
} catch (SQLException e) {
e.printStackTrace()
}
}
7.执行命令
//import java.sql.*
Connection conn=null
PreparedStatement pst=null
try {
conn=DriverManager.getConnection(url)
pst=conn.prepareStatement("Insert Into grade(%%1) Values (?)")
pst.setInt(1,%%2)
//pst.setString(2,%%2)
pst.addBatch()
pst.executeBatch()
} catch (SQLException e){
e.printStackTrace()
}
finally{
try {
if (pst != null)
pst.close()
if (conn != null)
conn.close()
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace()
}
}
jdbc从数据库里取数据的resultset,然后拼装成list或是string通过request.setattribute(list,list)方法传递到前台,使用select%listlist=(list)request.getattribute(list)for(inti=0ilist.size()i++)
%/select
java向数据库中插入数据,可以使用mysql数据库,使用statement类来 *** 作数据库,示例如下:
Connection conn = nullStatement st = null
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")//加载驱动类
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://<server_name>:<1433>", "name","pwd")
conn.setAutoCommit(false)
st = conn.createStatement()
// 模拟一个 str[i] = nd.getNodeValue().trim()
String[] str = new String[] { "aaa", "bbb", "ccc", "ddd", "eee","fff" }
String sqlStr = null
for (int i = 0 i < str.length i++) {
sqlStr = "INSERT INTO <TABLENAME> (<COLNAME>)VALUES('" + str[i] + "')"//向数据库中插入数据
st.executeUpdate(sqlStr)
}
conn.commit()
} catch (Exception e) {
e.printStackTrace()
} finally {//释放数据库的资源
try {
if (st != null)
st.close()
if(conn != null && !conn.isClosed()){
conn.close()
}
} catch (SQLException e) {
e.printStackTrace()
}
}
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)