-
大小: 0.28M文件類型: .zip金幣: 1下載: 0 次發(fā)布日期: 2021-02-20
- 語(yǔ)言: Java
- 標(biāo)簽:
資源簡(jiǎn)介
Java 將用戶選擇的愛(ài)好以字符串形式保存到數(shù)據(jù)庫(kù)(基礎(chǔ)篇-實(shí)例516).zip
代碼片段和文件信息
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.SQLException;
public?class?InsertString?{
????private?Connection?conn;
????//?獲取數(shù)據(jù)庫(kù)連接
????public?Connection?getConn()?{
????????try?{
????????????Class.forName(“net.sourceforge.jtds.jdbc.Driver“);?//?加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)
????????}?catch?(ClassNotFoundException?e)?{
????????????e.printStackTrace();
????????}
????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db_database22“;?//?連接數(shù)據(jù)庫(kù)URL
????????String?userName?=?“sa“;?//?連接數(shù)據(jù)庫(kù)的用戶名
????????String?passWord?=?““;?//?連接數(shù)據(jù)庫(kù)密碼
????????try?{
????????????conn?=?DriverManager.getConnection(url?userName?passWord);?//?獲取數(shù)據(jù)庫(kù)連接
????????????if?(conn?!=?null)?{
????????????}
????????}?catch?(SQLException?e)?{
????????????e.printStackTrace();
????????}
????????return?conn;?//?返回Connection對(duì)象
????}
????
????public?void?insertUsers(String?name?String?loves)?{
????????conn?=?getConn();?//?獲取數(shù)據(jù)庫(kù)連接
????????try?{
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2015-08-28?13:52??.classpath
?????文件?????????379??2015-08-28?13:52??.project
?????文件?????????629??2015-08-28?13:52??.settings\org.eclipse.jdt.core.prefs
?????文件????????1759??2015-08-28?13:52??bin\InsertString.class
?????文件?????????712??2015-08-28?13:52??bin\ToStringfr
?????文件?????????663??2015-08-28?13:52??bin\ToStringfr
?????文件?????????665??2015-08-28?13:52??bin\ToStringfr
?????文件?????????665??2015-08-28?13:52??bin\ToStringfr
?????文件?????????665??2015-08-28?13:52??bin\ToStringfr
?????文件?????????665??2015-08-28?13:52??bin\ToStringfr
?????文件?????????665??2015-08-28?13:52??bin\ToStringfr
?????文件?????????665??2015-08-28?13:52??bin\ToStringfr
?????文件????????4884??2015-08-28?13:52??bin\ToStringfr
?????文件??????294726??2015-08-28?13:52??lib\jtds-1.2.2.jar
?????文件????????1462??2015-08-28?13:52??src\InsertString.java
?????文件????????5748??2015-08-28?13:52??src\ToStringfr
- 上一篇:Java 完全連接查詢
- 下一篇:Java 從表中隨機(jī)返回記錄
評(píng)論
共有 條評(píng)論