锐客网

  1. 首页 > 睿知 > it技术 > >

java插入数据库的代码 java接入数据库

数据库IT技术

java连接数据库的代码用这个类吧.好的话,给我加加分.
import java.sql.*;
/**
* @功能: 一个JDBC的本地化API连接类,封装了数据操作方法,只用传一个SQL语句即可
* @作者: 李开欢
* @日期: 2007/
*/
public class ConnectionDemo {
/*
* 这里可以将常量全部放入另一个类中,以方便修改
*/
private static Connection conn;
private static Statement ps;
private static ResultSet rs;
private static final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
private static final String USER ="sa";
private static final String PASS = "sa";
public ConnectionDemo() {
// TODO Auto-generated constructor stub
ConnectionDemo.getConnection();
}
public static Connection getConnection(){
System.out.println("连接中...");
try {
Class.forName(ConnectionDemo.DRIVER);
conn = DriverManager.getConnection(ConnectionDemo.URL, ConnectionDemo.USER, ConnectionDemo.PASS);
System.out.println("成功连接");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
publicstatic Statement getStatement(String sql){
System.out.println("执行SQL语句中...");
try {
ps = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
if(sql.substring(0, 6).equals("select")){
rs = ps.executeQuery(sql);
System.out.println("执行完查询操作,结果已返回ResultSet集合");
}else if(sql.substring(0, 6).equals("delete")){
ps.executeUpdate(sql);
System.out.println("已执行完毕删除操作");
}else if(sql.substring(0, 6).equals("insert")){
ps.executeUpdate(sql);
System.out.println("已执行完毕增加操作");
}else{
ps.executeUpdate(sql);
System.out.println("已执行完毕更新操作");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return ps;
}
public static ResultSet getResultSet(){
System.out.println("查询结果为:");
return rs;
}
public static void closeConnection(){
System.out.println("关闭连接中...");
try {
if (rs != null) {
rs.close();
System.out.println("已关闭ResultSet");
}
if (ps != null) {
ps.close();
System.out.println("已关闭Statement");
}
if (conn != null) {
conn.close();
System.out.println("已关闭Connection");
}
} catch (Exception e) {
// TODO: handle exception
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
ConnectionDemo.getConnection();
String sql = "delete from type where id = 1";
ConnectionDemo.getStatement(sql);
String sql2 = "insert into type values(1,'教学设备')";
ConnectionDemo.getStatement(sql2);
String sql1 = "select * from type";
ConnectionDemo.getStatement(sql1);
ResultSet rs = ConnectionDemo.getResultSet();
System.out.println("编号 " "类型");
try {
while(rs.next()){
System.out.print(" " rs.getInt(1) "");
System.out.println(rs.getString(2));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ConnectionDemo.closeConnection();
}
}
用java代码把txt文档中资料导入到数据库BufferedReader input;
try {
String s = new String();
input = new BufferedReader(new FileReader("f:\\123.txt"));
while ((s = input.readLine()) != null) { // 判断是否读到了最后一行
String info[] = s.split(" ");
System.out.println( info[0]" "info[1]" "info[2] );
}
input.close();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
把info[0]" "info[1]" "info[2]这三个值放在insert语句里就行了经过测试
java 向数据库插入数据java向数据库中插入数据，可以使用mysql数据库，使用statement类来操作数据库，示例如下：
Connection conn = null;
Statement 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; istr.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();
}
}
JAVA嵌入数据库：用java代码实现像数据库表中插入信息，怎么写？Java程序向数据库中插入数据java插入数据库的代码 ， 代码如下：
//首先创建数据库java插入数据库的代码，(access,oracle,mysql,sqlsever)其中之一java插入数据库的代码，其中access,sqlsever需要配置数据源(odbc);//然后再eclipse中创建类(ConnDb,Test ， TestBean)ConnDb功能为连接数据库，查询，插入，删除，修改数据的类，Test为含有main方法的测试类，TestBean为数据表中的字段属性及set,get方法//以下是ConnDb代码：package db;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;public class ConnDb {public Connection startConn(Connection conn){try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn = DriverManager.getConnection("jdbc:odbc:数据库","用户名", "密码");} catch (Exception e) {System.out.println("连接数据库时出现错误");}return conn; } public ArrayList executeQuery(String sql){Connection conn = null;Statement stmt = null;ResultSet rs = null;ArrayList list = new ArrayList();try {conn = startConn(conn);stmt = conn.createStatement();rs = stmt.executeQuery(sql);//sql为sql语句例如"select * from 表名"，从main方法中传进来，这里用的是ArrayList 类将查询结果存储起来while(rs.next()){TestBean tb = new TestBean();tb.setTid(rs.getString("tid"));tb.setTname(rs.getString("tname"));tb.setTinfo(rs.getString("tinfo"));list.add(tb);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{closeConn(rs,stmt,conn);}return list; }public void executeUpdate(String sql){Connection conn = null;Statement stmt = null;try {conn = startConn(conn);stmt = conn.createStatement();stmt.executeUpdate(sql);} catch (SQLException e) {System.out.println("修改 ， 插入或者删除数据库数据时发生错误!");}finally{closeConn(stmt,conn);} } public void closeConn(ResultSet rs,Statement stmt,Connection conn){try {if(rs != null){rs.close();}if(stmt != null){stmt.close();}if(conn != null){conn.close();}} catch (SQLException e) {// TODO Auto-generated catch blockSystem.out.println("关闭数据库的时候发生错误!");} } public void closeConn(Statement stmt,Connection conn){try {if(stmt != null){stmt.close();}if(conn != null){conn.close();}} catch (SQLException e) {// TODO Auto-generated catch blockSystem.out.println("关闭数据库的时候发生错误!");} }}
【java插入数据库的代码 java接入数据库】java插入数据库的代码的介绍就聊到这里吧，感谢你花时间阅读本站内容 ， 更多关于java接入数据库、java插入数据库的代码的信息别忘了在本站进行查找喔 。

    推荐阅读


    上一篇：myeclipse开发java java开发的mysql要学到什么程度

    下一篇：如何判断服务器是否能够连接外网？ 怎么检测服务器能不能外网