eclipse怎么把数据库内容显示在网页上 如何使用eclipse调用数据库中的内容，并将数据显示出来？...
\u5728eclipse\u4e2d\u7684jsp\u4e2d\u4ece\u6570\u636e\u5e93\u663e\u793a\u5185\u5bb9,\u5982\u4f55\u63a7\u5236\u663e\u793a\u5185\u5bb9\u683c\u5f0f\u5148\u8981\u95ee\u4e0b\uff0c\u6570\u636e\u4ece\u6570\u636e\u5e93\u4e2d\u53d6\u51fa\u6765\u4e86\u5417\uff1f
\u5982\u679c\u5df2\u7ecf\u53d6\u51fa\u6765\u90a3\u8981\u663e\u793a\u5c31\u597d\u529e\u4e86\uff0c\u76f4\u63a5\u5d4c\u5165\u9875\u9762\uff0c
\u6216\u8005\u7528\u6807\u7b7e\u90fd\u53ef\u4ee5\uff0c\u5f88\u7b80\u5355\u7684\u3002
\u6211\u7528\u7684\u6570\u636e\u5e93\u662fmysql\uff0c\u4e0b\u8f7d\u8fd9\u4e2a\u4e1c\u4e1cmysql-connector-java-5.1.15.zip\u89e3\u538b\u628amysql-connector-java-5.1.15-bin.jar\u5bfc\u5165\u5230\u4f60\u8981\u8fde\u63a5\u6570\u636e\u5e93\u7684\u9879\u76ee\u4e2d\uff08\u5e94\u8be5\u77e5\u9053\u600e\u4e48\u5bfc\u5165\u5427\uff01\uff09\u7136\u540e\u5c31\u662f\u4ee3\u7801\uff0c\u4ee5\u4e0b\u4ee3\u7801\u662f\u63d2\u5165\u6570\u636e\u5e93\u7684\u4f8b\u5b50
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import java.sql.*;
public class Login2 {
private Connection connection;
private JButton button1;
private JFrame frame;
private JLabel nameLabel,pwdLabel;
private JTextField nameTA,pwdTA;
private JPanel panel;
// private Statement stat;
private ResultSet rs;
public Login2()
{
String url = "jdbc:mysql://localhost:3306/\uff08\u6b64\u5904\u586b\u5199\u4f60\u521b\u5efa\u7684\u6570\u636e\u5e93\u540d\u5b57\uff09";
String username = "\uff08\u6b64\u5904\u586b\u5199\u4f60\u7684\u6570\u636e\u5e93\u7528\u6237\uff0c\u4f8b\u5982root\uff09";
String password = "\uff08\u6b64\u5904\u586b\u5199\u4f60\u7684\u6570\u636e\u5e93\u5b89\u88c5\u65f6\u8bbe\u7f6e\u7684\u5bc6\u7801\uff09";
//\u52a0\u8f7d\u9a71\u52a8\u7a0b\u5e8f\u4ee5\u8fde\u63a5\u6570\u636e\u5e93
try {
Class.forName( "org.gjt.mm.mysql.Driver" );
connection = DriverManager.getConnection(
url, username, password );
}
//\u6355\u83b7\u52a0\u8f7d\u9a71\u52a8\u7a0b\u5e8f\u5f02\u5e38
catch ( ClassNotFoundException cnfex ) {
System.err.println(
"\u88c5\u8f7d JDBC/ODBC \u9a71\u52a8\u7a0b\u5e8f\u5931\u8d25\u3002" );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}
//\u6355\u83b7\u8fde\u63a5\u6570\u636e\u5e93\u5f02\u5e38
catch ( SQLException sqlex ) {
System.err.println( "\u65e0\u6cd5\u8fde\u63a5\u6570\u636e\u5e93" );
sqlex.printStackTrace();
System.exit( 1 ); // terminate program
}
frame = new JFrame();
panel = new JPanel();
panel.setLayout(new GridLayout(3,2));
nameLabel = new JLabel("user");
pwdLabel = new JLabel("password");
nameTA = new JTextField();
pwdTA = new JTextField();
button1 = new JButton("insert");
button1.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String str1 = nameTA.getText();
String str2 = pwdTA.getText();
String str = "insert into user values('"+str1+"','"+str2+"')";
try {
// Statement stat = null;
PreparedStatement pstmt = connection.prepareStatement(str);
pstmt.executeUpdate();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
JOptionPane.showMessageDialog(null, "yes");
}
});
panel.add(nameLabel);
panel.add(nameTA);
panel.add(pwdLabel);
panel.add(pwdTA);
panel.add(button1);
frame.add(panel);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setSize(300,100);
frame.setVisible(true);
}
/**
* @param args
*/
public static void main(String[] args) {
Login2 l = new Login2();
}
}
\u8fd8\u6709\u95ee\u9898\u53ef\u4ee5\u7ee7\u7eed\u8054\u7cfb
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import java.sql.*;
public class Login2 {
private Connection connection;
private JButton button1;
private JFrame frame;
private JLabel nameLabel,pwdLabel;
private JTextField nameTA,pwdTA;
private JPanel panel;
// private Statement stat;
private ResultSet rs;
public Login2()
{
String url = "jdbc:mysql://localhost:3306/（此处填写你创建的数据库名字）";
String username = "（此处填写你的数据库用户，例如root）";
String password = "（此处填写你的数据库安装时设置的密码）";
//加载驱动程序以连接数据库
try {
Class.forName( "org.gjt.mm.mysql.Driver" );
connection = DriverManager.getConnection(
url, username, password );
}
//捕获加载驱动程序异常
catch ( ClassNotFoundException cnfex ) {
System.err.println(
"装载 JDBC/ODBC 驱动程序失败。" );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}
//捕获连接数据库异常
catch ( SQLException sqlex ) {
System.err.println( "无法连接数据库" );
sqlex.printStackTrace();
System.exit( 1 ); // terminate program
}
frame = new JFrame();
panel = new JPanel();
panel.setLayout(new GridLayout(3,2));
nameLabel = new JLabel("user");
pwdLabel = new JLabel("password");
nameTA = new JTextField();
pwdTA = new JTextField();
button1 = new JButton("insert");
button1.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String str1 = nameTA.getText();
String str2 = pwdTA.getText();
String str = "insert into user values('"+str1+"','"+str2+"')";
try {
// Statement stat = null;
PreparedStatement pstmt = connection.prepareStatement(str);
pstmt.executeUpdate();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
JOptionPane.showMessageDialog(null, "yes");
}
});
panel.add(nameLabel);
panel.add(nameTA);
panel.add(pwdLabel);
panel.add(pwdTA);
panel.add(button1);
frame.add(panel);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setSize(300,100);
frame.setVisible(true);
}
/**
* @param args
*/
public static void main(String[] args) {
Login2 l = new Login2();
}
}
1、学习一下javaweb
2、了解一下mvc。你这个算是完成了model层。需要继续完善controller，view层。
3、学习一下springmvc，了解一下modelandview。
4、了解一下前后端分离，你现在差的就是后端发布接口服务，以及前度调用接口服务和前端页面展示逻辑
绛旓細1銆佸湪椤圭洰涓坊鍔鏁版嵁搴椹卞姩鐨勪緷璧栥2銆佸湪椤圭洰涓垱寤轰竴涓暟鎹簱杩炴帴宸ュ叿绫伙紝鐢ㄤ簬杩炴帴鏁版嵁搴擄紝鎵цSQL璇彞绛夋搷浣溿3銆佺紪鍐欎竴涓猄ervlet锛屽湪鍏朵腑璋冪敤鏁版嵁搴撹繛鎺ュ伐鍏风被锛岃幏鍙栨暟鎹簱涓殑鏁版嵁锛灏嗘暟鎹瀛樺偍鍒皉equest瀵硅薄涓紝灏唕equest瀵硅薄杞彂鍒癑SP椤甸潰杩涜鏄剧ず銆4銆佸湪JSP椤甸潰涓娇鐢↗STL鍜孍L琛ㄨ揪寮忓鏁版嵁杩涜鏄剧ず銆5...
绛旓細1銆佺┖鐧藉鍙冲嚮Import閫夋嫨General閲岀殑ExistingProjectsintoWorkspace-Next锛孊rowse鎵惧埌瑕佸鍏ラ」鐩墍鍦紝閫変腑瑕佸鍏ョ殑椤圭洰鐐瑰嚮纭畾涓瀹氳鍕鹃塁opyprojectsintoeorkspace-Finish銆2銆佸鍏ユ湰鍦伴」鐩箣鍚庡厛杩涜閰嶇疆锛岄厤缃楠ゅ涓嬶細瀵煎叆椤圭洰鍙冲嚮maven-updateproject-OK銆3銆侀」鐩悕-鍙冲嚮-properties-resource淇敼瀛椾綋utf-8銆4...
绛旓細杩涘叆properties鏍囩鏍忥紝杈撳叆鑷繁鎵寤鏁版嵁搴鐩稿叧鍐呭锛屽皬缂栧湪oracle涓缓鐨勭敤鎴峰悕鏄渃ityinfo鈥濄傝繖涓姝ュ悇鑷殑淇℃伅鍙兘涓嶅悓锛岃鑷鍐冲畾銆傜劧鍚庡崟鍑烩淥K鈥濄11 涓婃鐐瑰嚮鈥淥K鈥濆悗锛屼細杩斿洖鍓嶄竴涓獥鍙ｏ紝杩欐椂锛Eclipse浼氭彁绀鸿姹傝緭鍏"user name"鐢ㄦ埛鍚嶏紝灏辨槸澶у鎵寤虹珛鐨勬暟鎹簱鐨勫悕绉帮紝涓嶆槸浠绘剰璧风殑鍚嶅瓧銆傝緭鍏ュ悗...
绛旓細1銆侀鍏堥渶瑕灏嗘暟鎹簱鐨凧DBC椹卞姩娣诲姞鍒伴」鐩簱涓紝鑻ヤ娇鐢ㄧ殑鏄疢aven椤圭洰锛屽彲浠ュ湪pomxml鏂囦欢涓坊鍔犵浉搴旂殑渚濊禆锛岃嫢鏄疢ySQL鏁版嵁搴擄紝鍙互娣诲姞MySQL鐨凧DBC椹卞姩渚濊禆銆2銆佺劧鍚庨渶瑕佷娇鐢↗DBC鏉ュ缓绔嬩笌鏁版嵁搴撶殑杩炴帴銆3銆佸叾娆′竴鏃﹀缓绔嬩簡鏁版嵁搴撹繛鎺ワ紝灏卞彲浠ユ墽琛屾煡璇㈡搷浣滀簡銆4銆佹渶鍚庡湪瀹屾垚鏌ヨ鎿嶄綔鍚庯紝璁板緱鍏抽棴鏁版嵁搴撹繛鎺ヤ互...
绛旓細String url = "jdbc:mysql://localhost:3306/锛堟澶勫～鍐欎綘鍒涘缓鐨鏁版嵁搴鍚嶅瓧锛";String username = "锛堟澶勫～鍐欎綘鐨勬暟鎹簱鐢ㄦ埛锛屼緥濡俽oot锛";String password = "锛堟澶勫～鍐欎綘鐨勬暟鎹簱瀹夎鏃惰缃殑瀵嗙爜锛";//鍔犺浇椹卞姩绋嬪簭浠ヨ繛鎺ユ暟鎹簱 try { Class.forName( "org.gjt.mm.mysql.Driver" );connectio...
绛旓細涓锛歄DBC 鏁版嵁婧 浜岋細鐩磋繛 涓锛夊紑濮 鎺у埗闈㈡澘 绠＄悊宸ュ叿 鏁版嵁婧(ODBC)鐢ㄦ埛DSN鎴栫郴缁烡SN 鐐规坊鍔 鎵惧埌"Microsoft Access Driver (*.mdb)",閫変腑,鍐嶇偣瀹屾垚>>鑷畾涔夋暟鎹簮鍚嶇О,鍙垱 涓涓柊鐨勬垨閫夋嫨宸茬粡鏈夌殑Access鏁版嵁搴(.mdb)鍏跺畠鍙互涓嶉 8. 纭畾>>纭畾 鍒版鏁版嵁婧愬凡缁忓缓绔嬫垚鍔 try{ Class....
绛旓細=java.lang.Integer.parseInt(strPage); if(intPage<1) intPage = 1; } //瑁呰浇JDBC椹卞姩绋嬪簭 Class.forName("com.mysql.jdbc.Driver").newInstance(); //杩炴帴鏁版嵁搴//localhost/bishe涓烘暟鎹簱锛寀ser涓簉oot,password涓簉oot sqlCon=java.sql.DriverManager.getConnection("jdbc:...
绛旓細鐢╦ava璇█鐨勮瘽锛宩dbc杩炴帴鍒鏁版嵁搴锛岄氳繃sql璇彞鑾峰緱cell鐨勫笺傜敤POI搴撴潵鐢熸垚涓涓猠xcel鏂囦欢锛屾妸鑾峰緱cell鍊煎啓鍒癳xcel鐨勭浉搴斿崟鍏冩牸鍐(鎴栬呯敤csvtokenizer杩欎釜搴擄紝鐢熸垚CSV鏂囦欢锛屼篃鍙互)
绛旓細鐒跺悗鍦ㄥ伐绋嬩笅闈㈢殑src鍙冲嚮鎺ヤ笅鏉ュ氨鏄灏涓嬭浇濂絁dbc椹卞姩鍣ㄧ矘璐村埌杩欎釜demo杩欎釜宸ョ▼涓嬮潰鐨刲ib涓嬮潰锛岀劧鍚庣偣鍑诲垰鎵嶇矘璐寸殑閭ｄ釜jar鍖咃紝鎵惧埌build path缁х画鎵惧埌add to build path,鍑虹幇鐨勭粨鏋滃涓婂浘鎵绀猴紝杩欐椂娣诲姞瀹屾垚涔嬪悗锛屾墠鍙互浣跨敤Eclipse杩炴帴My sql鏁版嵁搴 杩炴帴鏁版嵁搴撲唬鐮佸涓嬶紙闇瑕侀噸鐐规敞鎰忕殑鏄疌onnection connect=...
绛旓細鐢ㄥ惊鐜繚瀛 int index =0;while(rs.next){ Object obj = rs.get(index ++);}
